Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ManufacturerID (FK)(PK) | A unique system assigned identifier for the Manufacturer. | ID_MF | Identity | integer | Manufacturer(PA_MF) |
BrandName (FK)(PK) | A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. | NM_BRN | Name | varchar(40) | Brand(ID_BRN) |
EffectiveDate | Date a manufacturer - brand association is available for use. | DC_EF | EffectiveDate | date | |
ExpirationDate | Date a manufacturer - brand association is no longer available for use. | DC_EP | ExpirationDate | date | |
CurrentStatusCode | Current status of a ManufacturerBrand association. Valid values are A - Active I - Inactive | CD_STS | Code2Status | char(2) | |